﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using TT.Module.sysLogin;
using Exp.BillDLL.ety;
using System.Data;

namespace Exp.BillDLL.dao
{
    public class daoInvoiceHdr
    {
        etyBaeSystemParamter basSysParam;

        public daoInvoiceHdr(etyBaeSystemParamter ibasSysParam)
        {
            basSysParam = ibasSysParam;
        }

        public DataTable GetDtlPgBill(etyTmYmsYD inEty)
        {
            string sql = "select rownum YID,YD_NO,CUSTOMER client_id,CLIENT_NAME,YW_TYPE_DESC,SF_DESC,CITY_DESC,QX_DESC,YF_AMT,CREATE_TIME,qty,wgt,EXP_AMOUNT "
                +" from vw_charge_dtl "
                +" where create_time between to_date(:from_date,'yyyymmdd') AND to_date(:to_date,'yyyymmdd') "
                + " and CUSTOMER=:client_id and exp_amount is not null ";
            return basSysParam.SqlHelp.ExecuteReader(sql, inEty);
        }
    }
}
